{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Instructions","Cost Worksheet","Scoring Formula"],"not_rendered":{"images":1,"defined_names":3},"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":37,"n_cols":15,"rows_kept":37,"merged":[[1,1,1,2],[2,1,2,2],[5,1,5,2],[7,1,7,2],[8,1,8,2],[9,1,9,2],[17,1,17,2],[19,1,21,2],[22,1,22,2],[29,1,29,2]]}
[]
[null,"State of Georgia"]
[null,"In Conjunction with NASPO ValuePoint"]
[null,"Electronic Request for Proposals (\"eRFP\")"]
[null,"eRFP (Event) Number: 41900-DCH0000136"]
[null,"Event Name: Pharmacy Benefit Services"]
[null,"Attachment V - Pharmacy Clinical Management Services Cost Worksheet"]
[]
[null,"Instructions for Supplier"]
[null,"\nSuppliers are bidding on the Design, Development and Implementation (DDI), monthly Operations and Maintenance (O&M) costs, and  additional program support the Supplier will charge to administer the Pharmacy Clinical Management Services Program as described in the eRFP. Please refer to the instructions below, Attachment A eRFP document \"Section 5, Cost Proposal,\" Attachment C - Common Scope Requirements and Security Standards, and Attachment G - Pharmacy Clinical Management Services Scope of Work for details describing the scope of the Clinical Management Services to be provided before completing this Cost Worksheet."]
[null,1,"Supplier shall provide firm/fixed pricing for the service(s) and deliverables for which a response is being submitted to as described in the eRFP."]
[null,2,"Suppliers shall complete the Cost Proposal worksheet using the cells highlighted in yellow."]
[null,3,"Suppliers shall not modify any cells in the spreadsheet other than those highlighted yellow. The other cells are fixed or will calculate automatically."]
[null,4,"Suppliers shall insert 0 in any yellow highlighted cells that are not applicable or for which the proposed cost is zero ($0)."]
[null,5,"Suppliers shall not modify the formulas in the worksheets."]
[null,6,"For evaluation purposes, the total cost will be determined by the value found in D14 which is comprised of the total DDI (Table A) and O&M (Table B) Costs over a period of ten (10) years."]
[]
[null,"Instructions for Adjusting Costs One or More Years After the Effective Date of the Master Agreement  "]
[{"$nulls":14}," "]
[null,"For Participating Addenda signed one year or more years after the Effective Date of the Master Agreement, the cost will be adjusted using the Consumer Price Index Urban (CPI-U) to account for economic changes that may impact cost. "]
[]
[]
[null,"CPI-U for United States Adjustment Factor Calculation:",{"$nulls":12}," "]
[null,"CPI-U Index for the month and year of the execution of a Participating Addendum",{"$nulls":11}," "]
[null,"Less the CPI-U Index for the month and year of the Effective Date of the Master Agreement",{"$nulls":11}," "]
[null,"Equals Index Point Change",{"$nulls":11}," "]
[null,"Divided by CPI-U Index B: C/B = D",{"$nulls":11}," "]
[null,"Result multiplied by 100: D*100 = E: Equals CPI-U Inflation Percentage",{"$nulls":11}," "]
[null," ",{"$nulls":12}," "]
[null,"Steps to Adjust Costs for CPI-U",{"$nulls":12}," "]
[null,1,"Follow the link below to access the CPI-U data."]
[null,null,"https://www.bls.gov/cpi/tables/supplemental-files/home.htm"]
[null,2,"Select, download and save the file with the most recently published CPI-U data that is available for the month the Participating Addendum is signed. (Also find and select the CPI-U for when the Master Agreement was originally executed). Use the “All Items” CPI-U “Unadjusted indexes” values instead of the “Seasonally adjusted indexes” values."]
[null,3,"Enter the CPI-U value from the previous step in field C53 \"CPI-U for Participating Addendum Date.\"",{"$nulls":11}," "]
[null,4,"Enter the CPI-U value for the month of the Effective Date of the Master Agreement in C52 \"CPI-U for Master Agreement Date MM/DD/20YY.\" "]
[null,5,"The “CPI-U Inflation Percentage” will be calculated automatically based on the values from steps 3 and 4. This will also automatically update all the CPI-U Adjusted Price fields in the cost tables."]
[null,6,"CPI-U Adjusted Prices will be subject to negotiation upon execution of a Participating Addendum."]

{"sheet":"Cost Worksheet","index":1,"n_rows":56,"n_cols":27,"rows_kept":56,"merged":[[2,1,2,2],[5,1,5,2],[8,2,8,6],[9,2,9,6],[10,2,10,6],[11,2,11,6],[13,1,13,2],[13,3,13,6],[17,1,17,3],[24,1,24,2],[27,1,28,3],[27,4,27,5],[27,6,27,7],[27,8,27,9],[27,10,27,11],[27,12,27,13],[27,14,27,15],[27,16,27,17],[27,18,27,19],[27,20,27,21],[27,22,27,23],[27,24,28,25],[27,26,28,27],[29,1,29,3],[30,1,30,3],[31,1,31,3],[32,1,32,3],[33,1,33,3],[33,12,33,13],[33,14,33,15],[33,16,33,17],[33,18,33,19],[33,20,33,21],[33,22,33,23],[33,24,33,25],[33,26,33,27],[34,1,34,27],[37,1,37,3],[38,1,38,3],[38,4,38,5],[38,6,38,7],[38,8,38,9],[38,10,38,11],[38,12,38,13],[38,14,38,15],[38,16,38,17],[38,18,38,19],[38,20,38,21],[38,22,38,23],[38,24,39,24],[39,0,44,0],[39,2,39,3],[40,2,40,3],[41,2,41,3],[42,2,42,3],[43,2,43,3],[44,2,44,3],[45,1,46,23],[45,24,46,24],[47,1,47,24]]}
[]
[" ","State of Georgia"]
[" ","In Conjunction with NASPO ValuePoint"]
[null,"Electronic Request for Proposals (\"eRFP\")"]
[null,"eRFP (Event) Number: 41900-DCH0000136"]
[null,"Event Name: Pharmacy Benefit Services"]
[" ","Attachment V - Pharmacy Clinical Management Services Cost Worksheet"]
[" "," "]
[" ","SUPPLIER LEGAL ENTITY NAME:","NorthStar HealthCare Consulting"]
[null,"SUPPLIER REPRESENTATIVE NAME:","Emily Baker, Pharm.D., MBA, MHA "]
[" ","SUPPLIER REPRESENTATIVE TITLE:","President"]
[null,"DATE:","2024-05-13"]
[" "]
[null,"TOTAL EVALUATION COST AMOUNT (Sum of Evaluation Costs Below):",null,{"$f":"+Y34+D25","v":{"v":16544011.997438777,"d":"$16,544,012.00"}}]
[" ",null," "]
[null,"Table A"]
[null,"Instructions: Please enter the costs to implement your services and/or Solution."]
[null,"Service Design, Development, and Implementation (DDI) Cost"]
[null,null,"Initial Cost","CPI-U Adjusted Cost"]
[null,"Project Planning and Startup",{"v":145850,"d":"$145,850.00"},{"$f":"+C20*$C$56","v":{"v":145850,"d":"$145,850.00"}}]
[null,"Design, Development, and Testing",{"v":131350,"d":"$131,350.00"},{"$f":"+C21*$C$56","v":{"v":131350,"d":"$131,350.00"}}]
[null,"Operational Readiness and Production Cutover",{"v":107000,"d":"$107,000.00"},{"$f":"+C22*$C$56","v":{"v":107000,"d":"$107,000.00"}}]
[null,"Training",{"v":25000,"d":"$25,000.00"},{"$f":"+C23*$C$56","v":{"v":25000,"d":"$25,000.00"}}]
[null,"Acceptance, Deployment",{"v":98500,"d":"$98,500.00"},{"$f":"+C24*$C$56","v":{"v":98500,"d":"$98,500.00"}}]
[null,"Total DDI Costs:",null,{"$f":"SUM(D20:D24)","v":{"v":507700,"d":"$507,700.00"}}]
[]
[null,"Table B"]
[null,"Operations and Maintenance (O&M)",null,null,"Year 1",null,"Year 2",null,"Year 3",null,"Year 4",null,"Year 5",null,"Year 6",null,"Year 7",null,"Year 8",null,"Year 9",null,"Year 10",null,"10-Year Total for Pharmacy Clinical Management Services O&M Administration",null,"For Informational Purposes Only\nAnnual Average Clinical Management Services Administration Cost"]
[{"$nulls":4},"Initial Rate","CPI-U Adjusted Rate","Initial Rate","CPI-U Adjusted Rate","Initial Rate","CPI-U Adjusted Rate","Initial Rate","CPI-U Adjusted Rate","Initial Rate","CPI-U Adjusted Rate","Initial Rate","CPI-U Adjusted Rate","Initial Rate","CPI-U Adjusted Rate","Initial Rate","CPI-U Adjusted Rate","Initial Rate","CPI-U Adjusted Rate","Initial Rate","CPI-U Adjusted Rate"]
[null,"Monthly Administration Fee"]
[null,"The monthly administration fee should include all the O&M costs to include, but not limited to the following:\n1.  State Advisory Board Support\n2.  Planning and Materials\n3.  Staffing\n4.  Utilization Management:  Development and Maintenance of PA Criteria for PDL and PADL \n5.  Technology Services (e.g., Document Repository)                                                                       \n(See Attachment  G - Pharmacy Clinical Management Services Scope of Work)"]
[null,"Total Monthly Cost",null,null,{"v":122500,"d":"$122,500"},{"$f":"E32*C56","v":{"v":122500,"d":"$122,500"}},{"v":110085,"d":"$110,085"},{"$f":"G32*C56","v":{"v":110085,"d":"$110,085"}},{"$f":"G32*1.05","v":{"v":115589.25,"d":"$115,589"}},{"$f":"I32*C56","v":{"v":115589.25,"d":"$115,589"}},{"$f":"I32*1.05","v":{"v":121368.71250000001,"d":"$121,369"}},{"$f":"K32*C56","v":{"v":121368.71250000001,"d":"$121,369"}},{"$f":"K32*1.05","v":{"v":127437.14812500002,"d":"$127,437"}},{"$f":"M32*C56","v":{"v":127437.14812500002,"d":"$127,437"}},{"$f":"M32*1.05","v":{"v":133809.00553125003,"d":"$133,809"}},{"$f":"O32*C56","v":{"v":133809.00553125003,"d":"$133,809"}},{"$f":"O32*1.05","v":{"v":140499.45580781254,"d":"$140,499"}},{"$f":"Q32*C56","v":{"v":140499.45580781254,"d":"$140,499"}},{"$f":"Q32*1.05","v":{"v":147524.42859820317,"d":"$147,524"}},{"$f":"S32*C56","v":{"v":147524.42859820317,"d":"$147,524"}},{"$f":"S32*1.05","v":{"v":154900.65002811333,"d":"$154,901"}},{"$f":"U32*C56","v":{"v":154900.65002811333,"d":"$154,901"}},{"$f":"U32*1.05","v":{"v":162645.68252951902,"d":"$162,646"}},{"$f":"W32*C56","v":{"v":162645.68252951902,"d":"$162,646"}}]
[{"$nulls":4},{"v":12,"d":"X 12"},"months",{"v":12,"d":"X 12"},"months",{"v":12,"d":"X 12"},"months",{"v":12,"d":"X 12"},"months",{"v":12,"d":"X 12"},"months",{"v":12,"d":"X 12"},"months",{"v":12,"d":"X 12"},"months",{"v":12,"d":"X 12"},"months",{"v":12,"d":"X 12"},"months",{"v":12,"d":"X 12"},"months"]
[null,"Total Period Cost",null,null,{"$f":"F32*E33","v":{"v":1470000,"d":"= $ 1,470,000"}},null,{"$f":"H32*G33","v":{"v":1321020,"d":"= $ 1,321,020"}},null,{"$f":"J32*I33","v":{"v":1387071,"d":"= $ 1,387,071"}},null,{"$f":"L32*K33","v":{"v":1456424.55,"d":"= $ 1,456,425"}},null,{"$f":"N32*M33","v":{"v":1529245.7775000003,"d":"= $ 1,529,246"}},null,{"$f":"P32*O33","v":{"v":1605708.0663750004,"d":"= $ 1,605,708"}},null,{"$f":"R32*Q33","v":{"v":1685993.4696937506,"d":"= $ 1,685,993"}},null,{"$f":"T32*S33","v":{"v":1770293.143178438,"d":"= $ 1,770,293"}},null,{"$f":"V32*U33","v":{"v":1858807.80033736,"d":"= $ 1,858,808"}},null,{"$f":"X32*W33","v":{"v":1951748.1903542283,"d":"= $ 1,951,748"}},null,{"$f":"SUM(E34:W34)","v":{"v":16036311.997438777,"d":"= $ 16,036,312"}},null,{"$f":"Y34/10","v":{"v":1603631.1997438776,"d":"= $ 1,603,631"}}]
[]
[]
[null,"Table C "]
[null,"Instructions: Complete the section below by entering the Hourly Rate in the yellow boxes for each identified Role. As may be requested by the State on a case by case basis and agreed upon by the Contractor, the Contractor will provide ad hoc services related to potential tasks as described below.\n\nNote: These charges will only be billed for project-related services not specified in the eRFP and requested by the State for such services in writing. The total cost for all State requested and approved projects shall not exceed the amount indicated by the State in its Participating Addendum. The proposed costs will not be evaluated as part of the total contract value."]
["Staff Roles and Responsibilities","Ad Hoc Professional Services",null,null,"Year 1",null,"Year 2",null,"Year 3",null,"Year 4",null,"Year 5",null,"Year 6",null,"Year 7",null,"Year 8",null,"Year 9",null,"Year 10",null,"10-Year Average of Hourly Rates"]
[null,"Role","Potential Responsibilities",null,"Initial Hourly Rate","CPI-U Adjusted Rate","Initial Hourly Rate","CPI-U Adjusted Rate","Initial Hourly Rate","CPI-U Adjusted Rate","Initial Hourly Rate","CPI-U Adjusted Rate","Initial Hourly Rate","CPI-U Adjusted Rate","Initial Hourly Rate","CPI-U Adjusted Rate","Initial Hourly Rate","CPI-U Adjusted Rate","Initial Hourly Rate","CPI-U Adjusted Rate","Initial Hourly Rate","CPI-U Adjusted Rate","Initial Hourly Rate","CPI-U Adjusted Rate"]
[null,"Clinical Pharmacist / Account Manager","Provides clinical consulting services for special projects. ",null,{"v":175,"d":"$175.00"},{"$f":"MAX(ROUND(E41*$C$56,2),0)","v":{"v":175,"d":"$175.00"}},{"$f":"E41*1.05","v":{"v":183.75,"d":"$183.75"}},{"$f":"MAX(ROUND(G41*$C$56,2),0)","v":{"v":183.75,"d":"$183.75"}},{"$f":"G41*1.05","v":{"v":192.9375,"d":"$192.94"}},{"$f":"MAX(ROUND(I41*$C$56,2),0)","v":{"v":192.94,"d":"$192.94"}},{"$f":"I41*1.05","v":{"v":202.58437500000002,"d":"$202.58"}},{"$f":"MAX(ROUND(K41*$C$56,2),0)","v":{"v":202.58,"d":"$202.58"}},{"$f":"K41*1.05","v":{"v":212.71359375000003,"d":"$212.71"}},{"$f":"MAX(ROUND(M41*$C$56,2),0)","v":{"v":212.71,"d":"$212.71"}},{"$f":"M41*1.05","v":{"v":223.34927343750005,"d":"$223.35"}},{"$f":"MAX(ROUND(O41*$C$56,2),0)","v":{"v":223.35,"d":"$223.35"}},{"$f":"O41*1.05","v":{"v":234.51673710937504,"d":"$234.52"}},{"$f":"MAX(ROUND(Q41*$C$56,2),0)","v":{"v":234.52,"d":"$234.52"}},{"$f":"Q41*1.05","v":{"v":246.2425739648438,"d":"$246.24"}},{"$f":"MAX(ROUND(S41*$C$56,2),0)","v":{"v":246.24,"d":"$246.24"}},{"$f":"S41*1.05","v":{"v":258.554702663086,"d":"$258.55"}},{"$f":"MAX(ROUND(U41*$C$56,2),0)","v":{"v":258.55,"d":"$258.55"}},{"$f":"U41*1.05","v":{"v":271.48243779624033,"d":"$271.48"}},{"$f":"MAX(ROUND(W41*$C$56,2),0)","v":{"v":271.48,"d":"$271.48"}},{"$f":"(F41+H41+J41+L41+N41+P41+R41+T41+V41+X41)/10","v":{"v":220.112,"d":"$220.11"}}]
[null,"Business Analyst","Evaluates business processes, anticipating requirements, uncovering areas for improvement, and developing and implementing Solutions.",null,{"v":100,"d":"$100.00"},{"$f":"MAX(ROUND(E42*$C$56,2),0)","v":{"v":100,"d":"$100.00"}},{"$f":"E42*1.05","v":{"v":105,"d":"$105.00"}},{"$f":"MAX(ROUND(G42*$C$56,2),0)","v":{"v":105,"d":"$105.00"}},{"$f":"G42*1.05","v":{"v":110.25,"d":"$110.25"}},{"$f":"MAX(ROUND(I42*$C$56,2),0)","v":{"v":110.25,"d":"$110.25"}},{"$f":"I42*1.05","v":{"v":115.7625,"d":"$115.76"}},{"$f":"MAX(ROUND(K42*$C$56,2),0)","v":{"v":115.76,"d":"$115.76"}},{"$f":"K42*1.05","v":{"v":121.55062500000001,"d":"$121.55"}},{"$f":"MAX(ROUND(M42*$C$56,2),0)","v":{"v":121.55,"d":"$121.55"}},{"$f":"M42*1.05","v":{"v":127.62815625000002,"d":"$127.63"}},{"$f":"MAX(ROUND(O42*$C$56,2),0)","v":{"v":127.63,"d":"$127.63"}},{"$f":"O42*1.05","v":{"v":134.00956406250003,"d":"$134.01"}},{"$f":"MAX(ROUND(Q42*$C$56,2),0)","v":{"v":134.01,"d":"$134.01"}},{"$f":"Q42*1.05","v":{"v":140.71004226562505,"d":"$140.71"}},{"$f":"MAX(ROUND(S42*$C$56,2),0)","v":{"v":140.71,"d":"$140.71"}},{"$f":"S42*1.05","v":{"v":147.74554437890632,"d":"$147.75"}},{"$f":"MAX(ROUND(U42*$C$56,2),0)","v":{"v":147.75,"d":"$147.75"}},{"$f":"U42*1.05","v":{"v":155.13282159785163,"d":"$155.13"}},{"$f":"MAX(ROUND(W42*$C$56,2),0)","v":{"v":155.13,"d":"$155.13"}},{"$f":"(F42+H42+J42+L42+N42+P42+R42+T42+V42+X42)/10","v":{"v":125.779,"d":"$125.78"}}]
[null,"Senior Developer","Responsible for designing, testing, and implementing new and updated software programs.",null,{"v":162.5,"d":"$162.50"},{"$f":"MAX(ROUND(E43*$C$56,2),0)","v":{"v":162.5,"d":"$162.50"}},{"v":170.625,"d":"$170.63"},{"$f":"MAX(ROUND(G43*$C$56,2),0)","v":{"v":170.63,"d":"$170.63"}},{"v":179.15625,"d":"$179.16"},{"$f":"MAX(ROUND(I43*$C$56,2),0)","v":{"v":179.16,"d":"$179.16"}},{"v":188.11406250000002,"d":"$188.11"},{"$f":"MAX(ROUND(K43*$C$56,2),0)","v":{"v":188.11,"d":"$188.11"}},{"v":197.51976562500002,"d":"$197.52"},{"$f":"MAX(ROUND(M43*$C$56,2),0)","v":{"v":197.52,"d":"$197.52"}},{"v":207.39575390625004,"d":"$207.40"},{"$f":"MAX(ROUND(O43*$C$56,2),0)","v":{"v":207.4,"d":"$207.40"}},{"v":217.76554160156255,"d":"$217.77"},{"$f":"MAX(ROUND(Q43*$C$56,2),0)","v":{"v":217.77,"d":"$217.77"}},{"v":228.65381868164067,"d":"$228.65"},{"$f":"MAX(ROUND(S43*$C$56,2),0)","v":{"v":228.65,"d":"$228.65"}},{"v":240.08650961572272,"d":"$240.09"},{"$f":"MAX(ROUND(U43*$C$56,2),0)","v":{"v":240.09,"d":"$240.09"}},{"v":252.09083509650887,"d":"$252.09"},{"$f":"MAX(ROUND(W43*$C$56,2),0)","v":{"v":252.09,"d":"$252.09"}},{"$f":"(F43+H43+J43+L43+N43+P43+R43+T43+V43+X43)/10","v":{"v":204.392,"d":"$204.39"}}]
[null,"Developer","Responsible for developing, coding, installing, and maintaining software systems.",null,{"v":137.5,"d":"$137.50"},{"$f":"MAX(ROUND(E44*$C$56,2),0)","v":{"v":137.5,"d":"$137.50"}},{"v":144.375,"d":"$144.38"},{"$f":"MAX(ROUND(G44*$C$56,2),0)","v":{"v":144.38,"d":"$144.38"}},{"v":151.59375,"d":"$151.59"},{"$f":"MAX(ROUND(I44*$C$56,2),0)","v":{"v":151.59,"d":"$151.59"}},{"v":159.1734375,"d":"$159.17"},{"$f":"MAX(ROUND(K44*$C$56,2),0)","v":{"v":159.17,"d":"$159.17"}},{"v":167.132109375,"d":"$167.13"},{"$f":"MAX(ROUND(M44*$C$56,2),0)","v":{"v":167.13,"d":"$167.13"}},{"v":175.48871484375002,"d":"$175.49"},{"$f":"MAX(ROUND(O44*$C$56,2),0)","v":{"v":175.49,"d":"$175.49"}},{"v":184.26315058593752,"d":"$184.26"},{"$f":"MAX(ROUND(Q44*$C$56,2),0)","v":{"v":184.26,"d":"$184.26"}},{"v":193.47630811523442,"d":"$193.48"},{"$f":"MAX(ROUND(S44*$C$56,2),0)","v":{"v":193.48,"d":"$193.48"}},{"v":203.15012352099615,"d":"$203.15"},{"$f":"MAX(ROUND(U44*$C$56,2),0)","v":{"v":203.15,"d":"$203.15"}},{"v":213.30762969704597,"d":"$213.31"},{"$f":"MAX(ROUND(W44*$C$56,2),0)","v":{"v":213.31,"d":"$213.31"}},{"$f":"(F44+H44+J44+L44+N44+P44+R44+T44+V44+X44)/10","v":{"v":172.946,"d":"$172.95"}}]
[null,"Quality assurance/Test","Works with the development team to debug code, correct errors, and troubleshoot any issues with software code.",null,{"v":87.5,"d":"$87.50"},{"$f":"MAX(ROUND(E45*$C$56,2),0)","v":{"v":87.5,"d":"$87.50"}},{"v":91.875,"d":"$91.88"},{"$f":"MAX(ROUND(G45*$C$56,2),0)","v":{"v":91.88,"d":"$91.88"}},{"v":96.46875,"d":"$96.47"},{"$f":"MAX(ROUND(I45*$C$56,2),0)","v":{"v":96.47,"d":"$96.47"}},{"v":101.29218750000001,"d":"$101.29"},{"$f":"MAX(ROUND(K45*$C$56,2),0)","v":{"v":101.29,"d":"$101.29"}},{"v":106.35679687500001,"d":"$106.36"},{"$f":"MAX(ROUND(M45*$C$56,2),0)","v":{"v":106.36,"d":"$106.36"}},{"v":111.67463671875002,"d":"$111.67"},{"$f":"MAX(ROUND(O45*$C$56,2),0)","v":{"v":111.67,"d":"$111.67"}},{"v":117.25836855468752,"d":"$117.26"},{"$f":"MAX(ROUND(Q45*$C$56,2),0)","v":{"v":117.26,"d":"$117.26"}},{"v":123.1212869824219,"d":"$123.12"},{"$f":"MAX(ROUND(S45*$C$56,2),0)","v":{"v":123.12,"d":"$123.12"}},{"v":129.277351331543,"d":"$129.28"},{"$f":"MAX(ROUND(U45*$C$56,2),0)","v":{"v":129.28,"d":"$129.28"}},{"v":135.74121889812017,"d":"$135.74"},{"$f":"MAX(ROUND(W45*$C$56,2),0)","v":{"v":135.74,"d":"$135.74"}},{"$f":"(F45+H45+J45+L45+N45+P45+R45+T45+V45+X45)/10","v":{"v":110.05700000000002,"d":"$110.06"}}]
[null,"Total Ad Hoc Professional Services Cost (Sum of 10-Year Average of Hourly Rates for all Identified Roles)",{"$nulls":22},{"$f":"SUM(Y41:Y45)","v":{"v":833.286,"d":"$833.29"}}]
[]
[]
[]
[null,"Table D"]
[null,"Consumer Price Index Urban (CPI-U) Adjustment:"]
[null,"A. CPI-U for Master Agreement Date MM/DD/20YY:",{"v":0,"d":"0.000000"}]
[null,"B. CPI-U for Participating Addendum Date:",{"v":0,"d":"0.000000"}]
[null,"C. Index Point Change equals B minus A:",{"$f":"C53-C52","v":{"v":0,"d":"0.000000"}}]
[null,"D. Equals C divided by A:",{"$f":"IFERROR(C54/C52,0)","v":{"v":0,"d":"0.000000"}}]
[null,"E. CPI-U Inflation Percentage equals B plus 1.00:",{"$f":"C55+1","v":{"v":1,"d":"1.000000"}}]

{"sheet":"Scoring Formula","index":2,"n_rows":14,"n_cols":2,"rows_kept":14,"merged":[[1,1,1,2],[2,1,2,2],[5,1,5,2],[8,1,10,3],[11,1,11,3],[12,1,12,3],[13,1,14,3]]}
[]
[null,"State of Georgia"]
[null,"In Conjunction with NASPO ValuePoint"]
[null,"Electronic Request for Proposals (\"eRFP\")"]
[null,"eRFP (Event) Number: 41900-DCH0000136"]
[null,"Event Name: Pharmacy Benefit Services"]
[null,"Attachment V - Pharmacy Clinical Management Services Cost Worksheet"]
[]
[null,"Cost Scoring Formula"]
[]
[]
[null,"\nThe Supplier deemed to have the most competitive cost response overall, as determined by the Lead State, will receive the maximum score for the cost criteria. As a general rule, other Suppliers’ cost responses will receive a percentage of the maximum score based on the percentage differential between the most competitive cost proposal and the specific proposal in question. This cost scoring can be accomplished using the following formula:"]
[null,"\nL/R x P = Z\n\nL = Price of the Supplier's response with the lowest cost.\nR = Total cost of the Proposal being ranked.\nP = Total points available for cost scoring.\nZ = Assigned Points."]
[null,"EXAMPLE  - The Lead State receives responses from two Suppliers on an RFP.  The RFP assigned 700 possible points for technical scores and 300 possible points for cost scores. Supplier A's cost proposal is $50,000. Supplier B's cost proposal is $55,000. As Supplier A offered the lowest cost, Supplier A receives 300 points. The issuing officer can calculate the number of cost points to assign to Supplier B's cost score by using the formula noted above. As shown below, Supplier B's total cost score is 272.7 points.\n\nL/R x P = Z\n($50,000/$55,000) x 300 = Z\n.909 x 300 = Z\n272.7 = Z"]